﻿using System;
using System.Data;
using System.Data.Common;
using Hxj.Data;
using Hxj.Data.Common;

namespace RecruitStudents.Utility.Model
{
    /// <summary>
    /// 专业表实体
    /// </summary>
    public class TB_Sys_SpecialityKinds : Entity
    {
        public TB_Sys_SpecialityKinds() : base("TB_Sys_SpecialityKinds") { }

        #region Model
        private string _SpecialityKindsNO;
        private string _SpecialityKindsID;
        private string _SpecialityKindsName;
        private int? _Sort;
        private string _ExamYear;
        private decimal? _Fee_First;
        private decimal? _Fee_Second;
        private decimal? _Fee_Third;
        private decimal? _Fee_Fourth;
        private decimal? _Fee_Fifth;
        private decimal? _Fee_Sixth;
        private decimal? _CounterFee_First;
        private decimal? _CounterFee_Second;
        private decimal? _CounterFee_Third;
        private decimal? _CounterFee_Fourth;
        private decimal? _CounterFee_Fifth;
        private decimal? _CounterFee_Sixth;
        private string _IsActive;
        private string _IsSchool;
        private string _LimitSex;
        /// <summary>
        /// 专业编码
        /// </summary>
        public string SpecialityKindsNO
        {
            get { return _SpecialityKindsNO; }
            set
            {
                this.OnPropertyValueChange(_.SpecialityKindsNO, _SpecialityKindsNO, value);
                this._SpecialityKindsNO = value;
            }
        }
        /// <summary>
        /// 专业代码
        /// </summary>
        public string SpecialityKindsID
        {
            get { return _SpecialityKindsID; }
            set
            {
                this.OnPropertyValueChange(_.SpecialityKindsID, _SpecialityKindsID, value);
                this._SpecialityKindsID = value;
            }
        }
        /// <summary>
        /// 专业名称
        /// </summary>
        public string SpecialityKindsName
        {
            get { return _SpecialityKindsName; }
            set
            {
                this.OnPropertyValueChange(_.SpecialityKindsName, _SpecialityKindsName, value);
                this._SpecialityKindsName = value;
            }
        }
        /// <summary>
        /// 排序
        /// </summary>
        public int? Sort
        {
            get { return _Sort; }
            set
            {
                this.OnPropertyValueChange(_.Sort, _Sort, value);
                this._Sort = value;
            }
        }
        /// <summary>
        /// 考试年度
        /// </summary>
        public string ExamYear
        {
            get { return _ExamYear; }
            set
            {
                this.OnPropertyValueChange(_.ExamYear, _ExamYear, value);
                this._ExamYear = value;
            }
        }
        /// <summary>
        /// 初试缴费
        /// </summary>
        public decimal? Fee_First
        {
            get { return _Fee_First; }
            set
            {
                this.OnPropertyValueChange(_.Fee_First, _Fee_First, value);
                this._Fee_First = value;
            }
        }
        /// <summary>
        /// 复试缴费
        /// </summary>
        public decimal? Fee_Second
        {
            get { return _Fee_Second; }
            set
            {
                this.OnPropertyValueChange(_.Fee_Second, _Fee_Second, value);
                this._Fee_Second = value;
            }
        }
        /// <summary>
        /// 三试缴费
        /// </summary>
        public decimal? Fee_Third
        {
            get { return _Fee_Third; }
            set
            {
                this.OnPropertyValueChange(_.Fee_Third, _Fee_Third, value);
                this._Fee_Third = value;
            }
        }
        /// <summary>
        /// 四试缴费
        /// </summary>
        public decimal? Fee_Fourth
        {
            get { return _Fee_Fourth; }
            set
            {
                this.OnPropertyValueChange(_.Fee_Fourth, _Fee_Fourth, value);
                this._Fee_Fourth = value;
            }
        }
        /// <summary>
        /// 五试缴费
        /// </summary>
        public decimal? Fee_Fifth
        {
            get { return _Fee_Fifth; }
            set
            {
                this.OnPropertyValueChange(_.Fee_Fifth, _Fee_Fifth, value);
                this._Fee_Fifth = value;
            }
        }
        /// <summary>
        /// 六试缴费
        /// </summary>
        public decimal? Fee_Sixth
        {
            get { return _Fee_Sixth; }
            set
            {
                this.OnPropertyValueChange(_.Fee_Sixth, _Fee_Sixth, value);
                this._Fee_Sixth = value;
            }
        }
        /// <summary>
        /// 初试手续费
        /// </summary>
        public decimal? CounterFee_First
        {
            get { return _CounterFee_First; }
            set
            {
                this.OnPropertyValueChange(_.CounterFee_First, _CounterFee_First, value);
                this._CounterFee_First = value;
            }
        }
        /// <summary>
        /// 复试手续费
        /// </summary>
        public decimal? CounterFee_Second
        {
            get { return _CounterFee_Second; }
            set
            {
                this.OnPropertyValueChange(_.CounterFee_Second, _CounterFee_Second, value);
                this._CounterFee_Second = value;
            }
        }
        /// <summary>
        /// 三试手续费
        /// </summary>
        public decimal? CounterFee_Third
        {
            get { return _CounterFee_Third; }
            set
            {
                this.OnPropertyValueChange(_.CounterFee_Third, _CounterFee_Third, value);
                this._CounterFee_Third = value;
            }
        }
        /// <summary>
        /// 四试手续费
        /// </summary>
        public decimal? CounterFee_Fourth
        {
            get { return _CounterFee_Fourth; }
            set
            {
                this.OnPropertyValueChange(_.CounterFee_Fourth, _CounterFee_Fourth, value);
                this._CounterFee_Fourth = value;
            }
        }
        /// <summary>
        /// 五试手续费
        /// </summary>
        public decimal? CounterFee_Fifth
        {
            get { return _CounterFee_Fifth; }
            set
            {
                this.OnPropertyValueChange(_.CounterFee_Fifth, _CounterFee_Fifth, value);
                this._CounterFee_Fifth = value;
            }
        }
        /// <summary>
        /// 六试手续费
        /// </summary>
        public decimal? CounterFee_Sixth
        {
            get { return _CounterFee_Sixth; }
            set
            {
                this.OnPropertyValueChange(_.CounterFee_Sixth, _CounterFee_Sixth, value);
                this._CounterFee_Sixth = value;
            }
        }
        /// <summary>
        /// 是否有效（1：开启   0：关闭）
        /// </summary>
        public string IsActive
        {
            get { return _IsActive; }
            set
            {
                this.OnPropertyValueChange(_.IsActive, _IsActive, value);
                this._IsActive = value;
            }
        }
        /// <summary>
        /// 是否校考（1：开启   0：无效）
        /// </summary>
        public string IsSchool
        {
            get { return _IsSchool; }
            set
            {
                this.OnPropertyValueChange(_.IsSchool, _IsSchool, value);
                this._IsSchool = value;
            }
        }
        /// <summary>
        /// 性别限制(0全部,1男,2女)
        /// </summary>
        public string LimitSex
        {
            get { return _LimitSex; }
            set
            {
                this.OnPropertyValueChange(_.LimitSex, _LimitSex, value);
                this._LimitSex = value;
            }
        }
        #endregion

        #region Method
        /// <summary>
        /// 获取实体中的主键列
        /// </summary>
        public override Field[] GetPrimaryKeyFields()
        {
            return new Field[] {
				_.SpecialityKindsNO};
        }
        /// <summary>
        /// 获取列信息
        /// </summary>
        public override Field[] GetFields()
        {
            return new Field[] {
				_.SpecialityKindsNO,
				_.SpecialityKindsID,
				_.SpecialityKindsName,
				_.Sort,
				_.ExamYear,
				_.Fee_First,
				_.Fee_Second,
				_.Fee_Third,
				_.Fee_Fourth,
				_.Fee_Fifth,
				_.Fee_Sixth,
				_.CounterFee_First,
				_.CounterFee_Second,
				_.CounterFee_Third,
				_.CounterFee_Fourth,
				_.CounterFee_Fifth,
				_.CounterFee_Sixth,
				_.IsActive,
				_.IsSchool,
				_.LimitSex};
        }
        /// <summary>
        /// 获取值信息
        /// </summary>
        public override object[] GetValues()
        {
            return new object[] {
				this._SpecialityKindsNO,
				this._SpecialityKindsID,
				this._SpecialityKindsName,
				this._Sort,
				this._ExamYear,
				this._Fee_First,
				this._Fee_Second,
				this._Fee_Third,
				this._Fee_Fourth,
				this._Fee_Fifth,
				this._Fee_Sixth,
				this._CounterFee_First,
				this._CounterFee_Second,
				this._CounterFee_Third,
				this._CounterFee_Fourth,
				this._CounterFee_Fifth,
				this._CounterFee_Sixth,
				this._IsActive,
				this._IsSchool,
				this._LimitSex};
        }
        /// <summary>
        /// 给当前实体赋值
        /// </summary>
        public override void SetPropertyValues(IDataReader reader)
        {
            this._SpecialityKindsNO = DataUtils.ConvertValue<string>(reader["SpecialityKindsNO"]);
            this._SpecialityKindsID = DataUtils.ConvertValue<string>(reader["SpecialityKindsID"]);
            this._SpecialityKindsName = DataUtils.ConvertValue<string>(reader["SpecialityKindsName"]);
            this._Sort = DataUtils.ConvertValue<int?>(reader["Sort"]);
            this._ExamYear = DataUtils.ConvertValue<string>(reader["ExamYear"]);
            this._Fee_First = DataUtils.ConvertValue<decimal?>(reader["Fee_First"]);
            this._Fee_Second = DataUtils.ConvertValue<decimal?>(reader["Fee_Second"]);
            this._Fee_Third = DataUtils.ConvertValue<decimal?>(reader["Fee_Third"]);
            this._Fee_Fourth = DataUtils.ConvertValue<decimal?>(reader["Fee_Fourth"]);
            this._Fee_Fifth = DataUtils.ConvertValue<decimal?>(reader["Fee_Fifth"]);
            this._Fee_Sixth = DataUtils.ConvertValue<decimal?>(reader["Fee_Sixth"]);
            this._CounterFee_First = DataUtils.ConvertValue<decimal?>(reader["CounterFee_First"]);
            this._CounterFee_Second = DataUtils.ConvertValue<decimal?>(reader["CounterFee_Second"]);
            this._CounterFee_Third = DataUtils.ConvertValue<decimal?>(reader["CounterFee_Third"]);
            this._CounterFee_Fourth = DataUtils.ConvertValue<decimal?>(reader["CounterFee_Fourth"]);
            this._CounterFee_Fifth = DataUtils.ConvertValue<decimal?>(reader["CounterFee_Fifth"]);
            this._CounterFee_Sixth = DataUtils.ConvertValue<decimal?>(reader["CounterFee_Sixth"]);
            this._IsActive = DataUtils.ConvertValue<string>(reader["IsActive"]);
            this._IsSchool = DataUtils.ConvertValue<string>(reader["IsSchool"]);
            this._LimitSex = DataUtils.ConvertValue<string>(reader["LimitSex"]);
        }
        /// <summary>
        /// 给当前实体赋值
        /// </summary>
        public override void SetPropertyValues(DataRow row)
        {
            this._SpecialityKindsNO = DataUtils.ConvertValue<string>(row["SpecialityKindsNO"]);
            this._SpecialityKindsID = DataUtils.ConvertValue<string>(row["SpecialityKindsID"]);
            this._SpecialityKindsName = DataUtils.ConvertValue<string>(row["SpecialityKindsName"]);
            this._Sort = DataUtils.ConvertValue<int?>(row["Sort"]);
            this._ExamYear = DataUtils.ConvertValue<string>(row["ExamYear"]);
            this._Fee_First = DataUtils.ConvertValue<decimal?>(row["Fee_First"]);
            this._Fee_Second = DataUtils.ConvertValue<decimal?>(row["Fee_Second"]);
            this._Fee_Third = DataUtils.ConvertValue<decimal?>(row["Fee_Third"]);
            this._Fee_Fourth = DataUtils.ConvertValue<decimal?>(row["Fee_Fourth"]);
            this._Fee_Fifth = DataUtils.ConvertValue<decimal?>(row["Fee_Fifth"]);
            this._Fee_Sixth = DataUtils.ConvertValue<decimal?>(row["Fee_Sixth"]);
            this._CounterFee_First = DataUtils.ConvertValue<decimal?>(row["CounterFee_First"]);
            this._CounterFee_Second = DataUtils.ConvertValue<decimal?>(row["CounterFee_Second"]);
            this._CounterFee_Third = DataUtils.ConvertValue<decimal?>(row["CounterFee_Third"]);
            this._CounterFee_Fourth = DataUtils.ConvertValue<decimal?>(row["CounterFee_Fourth"]);
            this._CounterFee_Fifth = DataUtils.ConvertValue<decimal?>(row["CounterFee_Fifth"]);
            this._CounterFee_Sixth = DataUtils.ConvertValue<decimal?>(row["CounterFee_Sixth"]);
            this._IsActive = DataUtils.ConvertValue<string>(row["IsActive"]);
            this._IsSchool = DataUtils.ConvertValue<string>(row["IsSchool"]);
            this._LimitSex = DataUtils.ConvertValue<string>(row["LimitSex"]);
        }
        #endregion

        #region _Field
        /// <summary>
        /// 字段信息
        /// </summary>
        public class _
        {
            /// <summary>
            /// * 
            /// </summary>
            public readonly static Field All = new Field("*", "TB_Sys_SpecialityKinds");
            /// <summary>
            /// 专业编码
            /// </summary>
            public readonly static Field SpecialityKindsNO = new Field("SpecialityKindsNO", "TB_Sys_SpecialityKinds", "专业编码");
            /// <summary>
            /// 专业代码
            /// </summary>
            public readonly static Field SpecialityKindsID = new Field("SpecialityKindsID", "TB_Sys_SpecialityKinds", "专业代码");
            /// <summary>
            /// 专业名称
            /// </summary>
            public readonly static Field SpecialityKindsName = new Field("SpecialityKindsName", "TB_Sys_SpecialityKinds", "专业名称");
            /// <summary>
            /// 排序
            /// </summary>
            public readonly static Field Sort = new Field("Sort", "TB_Sys_SpecialityKinds", "排序");
            /// <summary>
            /// 考试年度
            /// </summary>
            public readonly static Field ExamYear = new Field("ExamYear", "TB_Sys_SpecialityKinds", "考试年度");
            /// <summary>
            /// 初试缴费
            /// </summary>
            public readonly static Field Fee_First = new Field("Fee_First", "TB_Sys_SpecialityKinds", "初试缴费");
            /// <summary>
            /// 复试缴费
            /// </summary>
            public readonly static Field Fee_Second = new Field("Fee_Second", "TB_Sys_SpecialityKinds", "复试缴费");
            /// <summary>
            /// 三试缴费
            /// </summary>
            public readonly static Field Fee_Third = new Field("Fee_Third", "TB_Sys_SpecialityKinds", "三试缴费");
            /// <summary>
            /// 四试缴费
            /// </summary>
            public readonly static Field Fee_Fourth = new Field("Fee_Fourth", "TB_Sys_SpecialityKinds", "四试缴费");
            /// <summary>
            /// 五试缴费
            /// </summary>
            public readonly static Field Fee_Fifth = new Field("Fee_Fifth", "TB_Sys_SpecialityKinds", "五试缴费");
            /// <summary>
            /// 六试缴费
            /// </summary>
            public readonly static Field Fee_Sixth = new Field("Fee_Sixth", "TB_Sys_SpecialityKinds", "六试缴费");
            /// <summary>
            /// 初试手续费
            /// </summary>
            public readonly static Field CounterFee_First = new Field("CounterFee_First", "TB_Sys_SpecialityKinds", "初试手续费");
            /// <summary>
            /// 复试手续费
            /// </summary>
            public readonly static Field CounterFee_Second = new Field("CounterFee_Second", "TB_Sys_SpecialityKinds", "复试手续费");
            /// <summary>
            /// 三试手续费
            /// </summary>
            public readonly static Field CounterFee_Third = new Field("CounterFee_Third", "TB_Sys_SpecialityKinds", "三试手续费");
            /// <summary>
            /// 四试手续费
            /// </summary>
            public readonly static Field CounterFee_Fourth = new Field("CounterFee_Fourth", "TB_Sys_SpecialityKinds", "四试手续费");
            /// <summary>
            /// 五试手续费
            /// </summary>
            public readonly static Field CounterFee_Fifth = new Field("CounterFee_Fifth", "TB_Sys_SpecialityKinds", "五试手续费");
            /// <summary>
            /// 六试手续费
            /// </summary>
            public readonly static Field CounterFee_Sixth = new Field("CounterFee_Sixth", "TB_Sys_SpecialityKinds", "六试手续费");
            /// <summary>
            /// 是否有效（1：开启   0：关闭）
            /// </summary>
            public readonly static Field IsActive = new Field("IsActive", "TB_Sys_SpecialityKinds", "是否有效（1：开启   0：关闭）");
            /// <summary>
            /// 是否校考（1：开启   0：无效）
            /// </summary>
            public readonly static Field IsSchool = new Field("IsSchool", "TB_Sys_SpecialityKinds", "是否校考（1：开启   0：无效）");
            /// <summary>
            /// 性别限制(0全部,1男,2女)
            /// </summary>
            public readonly static Field LimitSex = new Field("LimitSex", "TB_Sys_SpecialityKinds", "性别限制(0全部,1男,2女)");
        }
        #endregion


    }
}

